SQL для тестировщика

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

www.tg-me.com/tw/SQL для тестировщика/com.sql_for_qa/116

2.0K viewsJun 30, 2023 at 09:11

tg-me.com/sql_for_qa/116

Create: 2023-06-30
Last Update: 2025-07-01 16:53:06

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/116

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram has exploded as a hub for cybercriminals looking to buy, sell and share stolen data and hacking tools, new research shows, as the messaging app emerges as an alternative to the dark web.An investigation by cyber intelligence group Cyberint, together with the Financial Times, found a ballooning network of hackers sharing data leaks on the popular messaging platform, sometimes in channels with tens of thousands of subscribers, lured by its ease of use and light-touch moderation.

Should You Buy Bitcoin?

In general, many financial experts support their clients’ desire to buy cryptocurrency, but they don’t recommend it unless clients express interest. “The biggest concern for us is if someone wants to invest in crypto and the investment they choose doesn’t do well, and then all of a sudden they can’t send their kids to college,” says Ian Harvey, a certified financial planner (CFP) in New York City. “Then it wasn’t worth the risk.” The speculative nature of cryptocurrency leads some planners to recommend it for clients’ “side” investments. “Some call it a Vegas account,” says Scott Hammel, a CFP in Dallas. “Let’s keep this away from our real long-term perspective, make sure it doesn’t become too large a portion of your portfolio.” In a very real sense, Bitcoin is like a single stock, and advisors wouldn’t recommend putting a sizable part of your portfolio into any one company. At most, planners suggest putting no more than 1% to 10% into Bitcoin if you’re passionate about it. “If it was one stock, you would never allocate any significant portion of your portfolio to it,” Hammel says.